Fric-frac Event Calendar logisch model
Home

Fric-frac Event Calendar logisch model

Fric-frac Event Calendar logisch model

Het logische datamodel beschrijft de structuur van en de referenties tussen de logische gegevensobjecten, die meer gelijken op tabellen dan op entiteiten.

Data Structure Diagram

Alle uitleg over de DSD van An Orm Apart vind je op Data Structure Diagram voor An Orm Apart.

Database: Docent1

Roepnaam database: Fric-Frac

Vendor: ModernWays

Tabel: Person

Roepnaam tabel: Persoon

Geordend op: FirstName, LastName

Column Name Display Text Searchable Default Value Unique Type Length Variable International Required Reference Table Reference Column Display Column List HTML element HTML type attribute Reserved HTML pattern attribute HTML title attribute HTML placeholder attribute
FirstName Voornaam NO NO NO CHAR 50 YES YES YES NA NA NA YES INPUT TEXT NA NA NA
LastName Achternaam SELECTX NO NO CHAR 120 YES YES YES NA NA NA YES INPUT TEXT NA NA NA
Email E-mail SELECTX NO NO CHAR 255 YES YES NO NA NA NA NO INPUT EMAIL NA NA jan.jannsens@mail.me
Password Wachtwoord NO NO NO CHAR 255 YES YES NO NA NA NA NO INPUT TEXT NA NA NA
Address1 Adres 1 NO NO NO CHAR 255 YES YES NO NA NA NA NO INPUT TEXT NA NA NA
Address2 Adres 2 NO NO NO CHAR 255 YES YES NO NA NA NA NO INPUT TEXT NA NA NA
PostalCode Postcode NO NO NO CHAR 20 YES NO NO NA NA NA NO INPUT TEXT NA NA NA
City Stad NO NO NO CHAR 80 YES YES NO NA NA NA NO INPUT TEXT NA NA NA
CountryId Land NO NO NO Integer NA NA NA NO Country Id Name NO SELECT NA NA NA NA
Phone1 Telefoon 1 NO NO NO CHAR 25 YES NA NO NA NA NA NO INPUT TEXT NA NA NA
Birthday Geboortedatum NO NO NO DATETIME NA NA NA NO NA NA NA NO INPUT DATE NA NA NA
Rating Tevreden NO NO NO Integer NA NA NA NO NA NA NA NO INPUT RANGE NA NA NA
GenderId Geslacht NO NO NO Integer NA NA NA NO Gender Id Name NO SELECT NA NA NA NA
Id NA NA PK YES Integer NA NA NA Yes NA NA NA YES INPUT HIDDEN NA NA NA

Tabel: Country

Roepnaam tabel: Land

Geordend op: Name

Column Name Display Text Searchable Default Value Unique Type Length Variable International Required Reference Table Reference Column Display Column List HTML element HTML type attribute Reserved HTML pattern attribute HTML title attribute HTML placeholder attribute
Name Naam SELECTX NO YES CHAR 50 YES YES YES NA NA NA YES INPUT TEXT NA NA NA
Code Code SELECTX NO YES CHAR 2 YES YES NO NA NA NA YES INPUT TEXT NA NA NA
Id NA NA PK YES Integer NA NA NA Yes NA NA NA YES INPUT HIDDEN NA NA NA

Gender

Geslacht

Name
Column Name Display Text Searchable Default Value Unique Type Length Variable International Required Reference Table Reference Column Display Column List HTML element HTML type attribute Reserved HTML pattern attribute HTML title attribute HTML placeholder attribute
Name Naam SELECTX NO YES CHAR 50 YES YES YES NA NA NA YES INPUT TEXT NA NA NA
Code Code SELECTBY NO YES CHAR 10 YES YES NO NA NA NA YES INPUT TEXT NA NA NA
Id NA NA PK YES Integer NA NA NA Yes NA NA NA YES INPUT HIDDEN NA NA NA

Role

Rol

Name
Column Name Display Text Searchable Default Value Unique Type Length Variable International Required Reference Table Reference Column Display Column List HTML element HTML type attribute Reserved HTML pattern attribute HTML title attribute HTML placeholder attribute
Name Naam SELECTBY NO YES CHAR 50 YES YES YES NA NA NA YES INPUT TEXT NA NA NA
Id NA NA PK YES Integer NA NA NA Yes NA NA NA YES INPUT HIDDEN NA NA NA

User

Gebruiker

Name
Column Name Display Text Searchable Default Value Unique Type Length Variable International Required Reference Table Reference Column Display Column List HTML element HTML type attribute Reserved HTML pattern attribute HTML title attribute HTML placeholder attribute
Name Naam SELECTX NO YES CHAR 50 YES YES YES NA NA NA YES INPUT TEXT NA NA NA
Salt Zout NA NO NO CHAR 255 YES YES NO NA NA NA YES INPUT TEXT NA NA NA
HashedPassword Hash NA NO NO CHAR 255 YES YES NO NA NA NA YES INPUT TEXT NA NA NA
PersonId Persoon Id NA NO NO Integer NA NA NA NO Person Id FirstName, LastName NO SELECT NA NA NA NA
RoleId Rol Id NA NO NO Integer NA NA NA NO Role Id Name NO SELECT NA NA NA NA
Id NA NA PK YES Integer NA NA NA Yes NA NA NA YES INPUT HIDDEN NA NA NA

EventCategory

Event categorie

Name
Column Name Display Text Searchable Default Value Unique Type Length Variable International Required Reference Table Reference Column Display Column List HTML element HTML type attribute Reserved HTML pattern attribute HTML title attribute HTML placeholder attribute
Name Naam SELECTX NO NO CHAR 120 YES YES YES NA NA NA YES INPUT TEXT NA NA NA
Id NA NA PK YES Integer NA NA NA Yes NA NA NA YES INPUT HIDDEN NA NA NA

EventTopic

Event topic

Name
Column Name Display Text Searchable Default Value Unique Type Length Variable International Required Reference Table Reference Column Display Column List HTML element HTML type attribute Reserved HTML pattern attribute HTML title attribute HTML placeholder attribute
Name Naam SELECTX NO NO CHAR 120 YES YES YES NA NA NA YES INPUT TEXT NA NA NA
Id NA NA PK YES Integer NA NA NA Yes NA NA NA YES INPUT HIDDEN NA NA NA

Event

Event

Name
Column Name Display Text Searchable Default Value Unique Type Length Variable International Required Reference Table Reference Column Display Column List HTML element HTML type attribute Reserved HTML pattern attribute HTML title attribute HTML placeholder attribute
Name Naam SELECTX NO NO CHAR 120 YES YES YES NA NA NA YES INPUT TEXT NA NA NA
Location Locatie SELECTX NO NO CHAR 120 YES YES YES NA NA NA YES INPUT TEXT NA NA NA
Starts Start NO NO NO DATETIME NA NA NA NO NA NA NA NO INPUT DATE NA NA NA
Ends Einde NO NO NO DATETIME NA NA NA NO NA NA NA NO INPUT DATE NA NA NA
Image Afbeelding NO NO NO CHAR 255 YES YES YES NA NA NA YES INPUT TEXT NA NA NA
Description Beschrijving NO NO NO CHAR 1024 YES YES YES NA NA NA YES INPUT TEXT NA NA NA
OrganiserName Organisator naam SELECTX NO NO CHAR 120 YES YES YES NA NA NA YES INPUT TEXT NA NA NA
OrganiserDescription Organisator beschrijving NO NO NO CHAR 120 YES YES YES NA NA NA YES INPUT TEXT NA NA NA
EventCategoryId EventCategoryId NA NO NO Integer NA NA NA NO Faculty Id Name NO SELECT NA NA NA NA
EventTopicId EventTopicId NA NO NO Integer NA NA NA NO Faculty Id Name NO SELECT NA NA NA NA
Id NA NA PK YES Integer NA NA NA Yes NA NA NA YES INPUT HIDDEN NA NA NA

JI
2017-09-06 14:59:02